package com.databasefunction;

import java.sql.*;

public class DatabaseConstants {
	// JDBC driver name and database URL

	public static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
	public static String DB_URL = "jdbc:mysql://localhost:3306/";

	// Database credentials
	public static final String USER = "root";
	public static final String PASS = "gaurav26993";

	// database table role for employee add table constants
	public static final String dbName = "parvati_database";
	public static final String userName = "userName";
	public static final String password = "password";
	public static final String role = "role";
	public static final String fullName = "fullName";
	public static final String address = "address";
	public static final String contact = "contact";
	public static final String emailId = "emailId";
	public static final String securityQuestion1 = "securityQuestion1";
	public static final String securityAnswer1 = "securityAnswer1";
	public static final String securityQuestion2 = "securityQuestion2";
	public static final String securityAnswer2 = "securityAnswer2";
	public static final String date = "date";

	// database constants for dealer table
	public static final String dealername = "name";
	public static final String dealerrole = "role";
	public static final String dealerUniqueid = "dealerUniqueid";
	public static final String dealeraddress = "address";
	public static final String dealercity = "city";
	public static final String dealerdistrict = "district";
	public static final String dealerstate = "state";
	public static final String dealercountry = "country";
	public static final String dealerzipcode = "zipcode";
	public static final String dealercontact = "contact";
	public static final String dealeremailid = "emailid";
	public static final String dealerdate = "date";

	// database constants for barcodeFinalTable

	public static final String barcodeNumber = "barcodeNumber";
	public static final String barcodeBrokerName = "brokerName";
	public static final String barcodecustomerName = "customerName";
	public static final String barcodeCommisionAgentName = "commisionAgentName";
	public static final String barcodeaddress = "address";
	public static final String barcodeRstNo = "rstNo";
	public static final String barcodeVehicleNo = "vehicleNo";
	public static final String barcodeCommodity = "commodity";
	public static final String barcodeNoOfBags = "NoOfBags";
	public static final String barcodePONo = "PONo";
	public static final String barcodeGrossWeight = "grossWeight";
	public static final String barcodeTareWeight = "TareWeight";
	public static final String barcodeNetWeight = "NetWeight";
	public static final String barcodedate = "date";
	public static final String barcodetime = "time";
	public static final String barcodeDamageSeeds = "damageSeeds";

	public static final String barcodeSandSilica = "sandSilica";
	public static final String barcodeMoisture = "moisture";
	public static final String barcodeExcessDamage = "excessDamage";
	public static final String barcodeExcessSandSilica = "excessSandSilica";
	public static final String barcodeExcessMoisture = "excessMoisture";
	public static final String barcodeDamageAmountCut = "damageAmount";
	public static final String barcodeSandSilicaAmountCut = "sandSilicaAmount";
	public static final String barcodeMoistureAmountCut = "moistureAmount";
	public static final String barcodeRate = "rate";
	public static final String barcodeGrossAmount = "grossAmount";
	public static final String barcodeLessRebate = "lessRebate";
	public static final String barcodeUnloading = "unloading";
	public static final String barcodecashDiscount = "cashDiscount";
	public static final String barcodeAdvance = "advance";
	public static final String barcodeAddDalali = "addDalali";
	public static final String barcodeTotalRebate = "totalRebate";
	public static final String barcodeTotalPaid = "totalPaid";
	public static final String barcodeHide = "hide";
	public static final String barcodeWeighingMachineUser = "weighingMachineUser";
	public static final String barcodeLabUser = "labUser";

	public static final int operation_insert = 0;
	public static final int operation_update = 1;

	// database constants for analysisreporttable
	public static final String analysisBarcode = "barcode";
	public static final String analysisAvailable = "availability";

	public static final int CITY = 0;
	public static final int DISTRICT = 1;

	//Analysis report constants
	 public static String ANALYSIS_BARCODE_COLUMN = "barcode"; 
}
